﻿--HEADER Add SecurityId to TradedQuantity
alter table [Analytics].[TradedQuantity]
add [SecurityId] INT NULL

GO

update [Analytics].[TradedQuantity]
set SecurityId = 0
where SecurityId is null

GO

alter table [Analytics].[TradedQuantity]
alter column [SecurityId] INT NOT NULL